﻿DROP TABLE IF EXISTS `open_group_promotion_goods_type`;
CREATE TABLE `open_group_promotion_goods_type` (
  `goods_type_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `group_promotion_id` int(11) unsigned NOT NULL DEFAULT '0',
  `goods_type_name` varchar(50) NOT NULL DEFAULT '',
  `goods_count` tinyint(3) unsigned NOT NULL DEFAULT '1',
  `is_present` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `add_money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`goods_type_id`),
  KEY `group_promotion_id` (`group_promotion_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;